README for "Estimate the Rate of Failure to Disclose Medical Conditions on FAA Medical Certification Exams [supporting datasets]" dataset. Bureau of Transportation Statistics (BTS), U.S. Department of Transportation (USDOT) 2023-12-05 ---------------------------------------------------------------- LINKS TO DATASET ---------------------------------------------------------------- A. Dataset archive link: https://doi.org/10.21949/1529865 ---------------------------------------------------------------- SUMMARY OF DATASET ---------------------------------------------------------------- Existing FAA databases can be used to estimate the rate of discrepancies between medical conditions reported during medical certification exams and conditions identified on autopsy after fatal aircraft accidents involving the same pilot. This may serve as a surrogate measure for how fully pilots disclose their medical conditions during FAA medical certification exams. The Civil Aerospace Medical Institute (CAMI) Medical ANalysis TRAcking registry (MANTRA) is an application used to store autopsy and civilian aviator aeromedical records data from fatal aircraft mishaps and is hosted at CAMI in Oklahoma City. MANTRA data is entered as both free text, discrete ICD codes, and line item words (for medications). Toxicological findings from ToxFlo, which is the application used by the toxicology lab for sample analyses, are used in conjunction with autopsy findings and aviator aeromedical records in an effort to identify aeromedical hazards. It is possible to perform the analysis of the accuracy of a self- reported medical history by direct comparison of both the autopsy and toxicology reports with the pilot’s medical records for each accident. MANTRA and ToxFlo databases will be searched by ICD and CPT codes and medication name as markers for specific diseases. Cases with these findings will be identified, and the relevant pilot records will be reviewed retrospectively to determine whether they reported these conditions during their medical exams. The rate of failure to accurately report will be calculated for select medical conditions. ---------------------------------------------------------------- TABLE OF CONTENTS ---------------------------------------------------------------- A. General Information B. Sharing/Access & Policies Information C. Data and Related File Overview D. Methodological Information E. Data-Specific Information for: Estimate the Rate of Failure to Disclose Medical Conditions on FAA Medical Certification Exams [supporting datasets] F. Update Log ---------------------------------------------------------------- A. GENERAL INFORMATION ---------------------------------------------------------------- 0. Title of Dataset: Estimate the Rate of Failure to Disclose Medical Conditions on FAA Medical Certification Exams [supporting datasets] 1. Description of Dataset: Existing FAA databases can be used to estimate the rate of discrepancies between medical conditions reported during medical certification exams and conditions identified on autopsy after fatal aircraft accidents involving the same pilot. This may serve as a surrogate measure for how fully pilots disclose their medical conditions during FAA medical certification exams. The Civil Aerospace Medical Institute (CAMI) Medical ANalysis TRAcking registry (MANTRA) is an application used to store autopsy and civilian aviator aeromedical records data from fatal aircraft mishaps and is hosted at CAMI in Oklahoma City. MANTRA data is entered as both free text, discrete ICD codes, and line item words (for medications). Toxicological findings from ToxFlo, which is the application used by the toxicology lab for sample analyses, are used in conjunction with autopsy findings and aviator aeromedical records in an effort to identify aeromedical hazards. It is possible to perform the analysis of the accuracy of a self-reported medical history by direct comparison of both the autopsy and toxicology reports with the pilot’s medical records for each accident. MANTRA and ToxFlo databases will be searched by ICD and CPT codes and medication name as markers for specific diseases. Cases with these findings will be identified, and the relevant pilot records will be reviewed retrospectively to determine whether they reported these conditions during their medical exams. The rate of failure to accurately report will be calculated for select medical conditions. 2. Dataset archive link: https://doi.org/10.21949/1529865 3. Authorship Information: Principal Data Creator or Data Manager Contact Information Name: McCluskey, Richard A, (0000-0003-0508-9617) Institution: Civil Aerospace Medical Institute Address: Mike Monroney Aeronautical Center Bldg. 13 (CAMI), Room 135D 6500 South MacArthur Blvd Oklahoma City, OK 73169 Email: richard.A.McCluskey@faa.gov Data Distributor Contact Information Name: McCluskey, Richard A, (0000-0003-0508-9617) Institution: Civil Aerospace Medical Institute Address: Mike Monroney Aeronautical Center Bldg. 13 (CAMI), Room 135D 6500 South MacArthur Blvd Oklahoma City, OK 73169 Email: richard.A.McCluskey@faa.gov Organizational Contact Information Name: McCluskey, Richard A, (0000-0003-0508-9617) Institution: Civil Aerospace Medical Institute Address: Mike Monroney Aeronautical Center Bldg. 13 (CAMI), Room 135D 6500 South MacArthur Blvd Oklahoma City, OK 73169 Email: richard.A.McCluskey@faa.gov 4. Date of data collection and update interval: 2008/10/01-2022/12/01 5. Geographic location of data collection: United States ---------------------------------------------------------------- B. SHARING/ACCESS & POLICIES INFORMATION ---------------------------------------------------------------- 0. Recommended citation for the data: United States. Department of Transportation. Federal Aviation Administration. Office of Aviation. Civil Aerospace Medical Institute (2023). Estimate the Rate of Failure to Disclose Medical Conditions on FAA Medical Certification Exams [supporting datasets]. https://doi.org/10.21949/1529865 1. Licenses/restrictions placed on the data: None 2. Was data derived from another source?: Yes 3. This document was created to meet the requirements enumerated in the U.S. Department of Transportation's 'Plan to Increase Public Access to the Results of Federally-Funded Scientific Research' Version 1.1 << https://doi.org/10.21949/1520559 >> and guidelines suggested by the DOT Public Access website << https://doi.org/10.21949/1503647 >>, in effect and current as of December 03, 2020. ---------------------------------------------------------------- C. DATA & RELATED FILE OVERVIEW ---------------------------------------------------------------- 1. File List for the 95530_DATASET_20231205.zip collection A. Filename: 1 archive 1-11-2011 - 1-10-2022 all stats.xlsx Short description: All fatalities report from 2011/11/1 through 2022/01/10. Excel file includes role of person, injury status, medication certification class, Basic Med course date, CMEC date, BasicMed Applied for, and Medical Certification Status. B. Filename: 1 archive mantra reported meds psych.xlsx Short description: Contains Excel worksheets with the roles of person, injury status, ICD code, description of psychiatric conditions, and what was detected in the autopsy. C. Filename: 1 archive tox post mortem report meds psych.xlsx Short description: Excel workbook that contains the ToxFlo data from the McCluskey study with the variables: the drug, casenumber, and whether it was fatal. D. Filename: 2 archive 10-01-2008 thru 12-31-2022 all Stats.xlsx Short description: All fatalities report from 2008/10/1 through 2022/12/31. Excel file includes role of person, injury status, medication certification class, Basic Med course date, CMEC date, BasicMed Applied for, and Medical Certification Status. E. Filename: 2 archive autopsy cardiac.xlsx Short description: Excel workbook with 3 sheets that contain the role of person, injury status, ICD code, CPT code, and code description for persons with cardiac diseases from each autopsy. F. Filename: 2 archive MANTRA history reported cardiac.xlsx Short description: Excel workbook with 3 sheets that contain the role of person, injury status, ICD code, CPT code, and code descriptions reported by the person. G. Filename: 95530_README_20231205.txt Short description: The document you are reading now. Contains information regarding the dataset, its description, its contents, and other important information. H. Filename: 95530.json Short description: This is the metadata file that contains important document information. This file is in DCAT US v1.1 schema. I. Filename: 1 archive 1-11-2011 - 1-10-2022 all stats_Medical Class.csv Short description: CSV version of excel table. J. Filename: 1 archive mantra reported meds psych_F32.9.csv Short description: CSV version of excel table sheet F32.9. K. Filename: 1 archive mantra reported meds psych_f41.9.csv Short description: CSV version of excel table sheet f41.9. L. Filename: 1 archive mantra reported meds psych_f43.10.csv Short description: CSV version of excel table sheet f43.10. M. Filename: 1 archive mantra reported meds psych_F43.21.csv Short description: CSV version of excel table sheet F43.21. N. Filename: 1 archive mantra reported meds psych_f43.9.csv Short description: CSV version of excel table sheet f43.9. O. Filename: 1 archive mantra reported meds psych_f90.9.csv Short description: CSV version of excel table sheet f90.9. P. Filename: 1 archive mantra reported meds psych_f98.8.csv Short description: CSV version of excel table sheet f98.8. Q. Filename: 1 archive tox post mortem report meds psych_ToxFlo Data for McCluskey study.csv Short description: CSV version of excel table. R. Filename: 2 archive 10-01-2008 thru 12-31-2022 all Stats_Medical Class.csv Short description: CSV version of excel table. S. Filename: 2 archive autopsy cardiac_33517.csv Short description: CSV version of excel table sheet 33517. T. Filename: 2 archive autopsy cardiac_92933.csv Short description: CSV version of excel table sheet 92933. U. Filename: 2 archive autopsy cardiac_I25.2.csv Short description: CSV version of excel table sheet I25.2. V. Filename: 2 archive MANTRA history reported cardiac_33517.csv Short description: CSV version of excel table sheet 33517. W. Filename: 2 archive MANTRA history reported cardiac_92933.csv Short description: CSV version of excel table sheet 92933. X. Filename: 2 archive MANTRA history reported cardiac_I25.2.csv Short description: CSV version of excel table sheet I25.2. ---------------------------------------------------------------- D. METHODOLOGICAL INFORMATION ---------------------------------------------------------------- 1. Description of methods used for collection/generation of data: The researchers used a combination of existing FAA databases to obtain this data. This includes the Medical ANalysis TRAcking registry (MANTRA) database, which stores autopsy information from fatal aircraft mishaps. It also includes toxicology findings from ToxFlo, which is the application used by the toxicology lab for sample analyses, are used in conjunction with autopsy findings and aviator aeromedical records in an effort to identify aeromedical hazards. 2. Instrument- or software-specific information needed to interpret the data: Spreadsheet software such as Excel, or any program that can open and read CSV files. ---------------------------------------------------------------- E. DATA-SPECIFIC INFORMATION ---------------------------------------------------------------- 1. 1 archive 1-11-2011 - 1-10-2022 all stats A. Number of variables (columns): 7 B. Number of cases/rows: 2391 C. Each row represents: A person D. Data Dictionary/Variable List: None included E. Missing data codes: S S = Appropriate Skip R = Refused D = Don't Know 2. 1 archive mantra reported meds psych A. Number of variables (columns): 29 B. Number of cases/rows: 166 C. Each row represents: A person D. Data Dictionary/Variable List: None included E. Missing data codes: S S = Appropriate Skip R = Refused D = Don't Know 3. 1 archive tox post mortem report meds psych A. Number of variables (columns): 3 B. Number of cases/rows: 376 C. Each row represents: A casenumber D. Data Dictionary/Variable List: None included E. Missing data codes: S S = Appropriate Skip R = Refused D = Don't Know 4. 2 archive 10-01-2008 thru 12-31-2022 all Stats A. Number of variables (columns): 7 B. Number of cases/rows: 4640 C. Each row represents: A person D. Data Dictionary/Variable List: None included E. Missing data codes: S S = Appropriate Skip R = Refused D = Don't Know 5. 2 archive autopsy cardiac A. Number of variables (columns): 12 B. Number of cases/rows: 236 C. Each row represents: A person D. Data Dictionary/Variable List: None included E. Missing data codes: S S = Appropriate Skip R = Refused D = Don't Know 6. 2 archive MANTRA history reported cardiac A. Number of variables (columns): 12 B. Number of cases/rows: 207 C. Each row represents: A person D. Data Dictionary/Variable List: None included E. Missing data codes: S S = Appropriate Skip R = Refused D = Don't Know ---------------------------------------------------------------- F. UPDATE LOG ---------------------------------------------------------------- This 95476_README_20231205.txt file was originally created on 2023-12-05 by Peyton Tvrdy https://orcid.org/0000-0002-9720-4725 Data Management and Data Curation Fellow, peyton.tvrdy.ctr@dot.gov 2023-12-05: Original file created